Round 1 - Technical

🔹 Introduce yourself

🔹 Question on current project and past experience(technology used, project architecture, day to day task in your project, size of daily data) 

🔹 What is ADF? is it ETL OR ELT?

🔹 What is linked service in ADF?

🔹 Difference between linked service and dataset?

🔹 What is ARM templates, how to move pipeline from dev to production environment?

🔹 What is Integration Runtime? Types of IR and usage in details?

🔹 What is Triggers in ADF and its types?

🔹 Explain storage and Tumbling window trigger?

🔹 What is Activity in ADF, name 5 activity used by you in project?

🔹 Explain copy activity, metadata activity, lookup activity, foreach activity?

🔹 What is mount point in azure databricks ,mount ADLS gen2 to databricks?

🔹 3 common roles in azure?

🔹 Spark Architecture, types of mode in spark?

🔹 What is Dataframe in pyspark? dataframe vs rdd?

🔹 Why is RDD resilient and fault tolerant?

🔹 Action vs Transformations?

🔹 Optimization techniques used by you in spark?

🔹 Reducebykey() vs Groupbykey()?

🔹 Diff by persist and cache?

Round 2 - Managerial 

🔹 Introduce yourself?

🔹 Project Architecture, Team size.

🔹 What is COALESCE() in sql?

🔹 What is window functions? row_number() vs rank() vs dense_rank()?

🔹 SnowFlake schema vs Star schema

🔹 One sql medium question

Round 3 - HR Discussion

🔹 Salary negotiations

Got Offer from Accenture😊